package com.woniuxy.factory.mapper;

import com.woniuxy.factory.entity.Schedule;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface ScheduleMapper {
    void insertSchedule(@Param("serialNumber") String serialNumber, @Param("planid") String planid, @Param("wosId") String wosId);

    int selectScheduleCounts(@Param("schedule") Schedule schedule);

    List<Schedule> selectAllSchedule(@Param("schedule")Schedule schedule, @Param("page") int page, @Param("limit") int limit);

    Schedule scheduleEcho(String serialNumber);

    void upadateSChedcule(Schedule schedule);

    void deleteSchedule(String serialNumber);

    int selectNumberSum(String planid);

    Schedule selectScheduleByPlanid(String planid);

    String selectMaterielByPlanid(String planid);

    Schedule selectScheudleState(String planid);

    /*查找所有状态为已完成的所有生产表，仓库调用*/
    List<Schedule> selectScheduleAchieve(Schedule schedule);

}
